SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 991828 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 991828 [ RunTime:0.002123s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (950825,366404,929215,10486,923073,751838,904569,935402,962033,442909,113575,263394,1014987,554750,596416,402107,771680,435412,442780,787672,740956,372551,134867,198712,935191,19053,709237,779978,731651,455784,671088,129362,725150,706827,64257,78577,442173,322727,202588,42617,717353,796733,375478,886538,802340,236227,331105,437463,929365,730576,478670,659238,425273,859810,357677,192624,735137,41983,834641,464104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 991828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 991828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]