SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034171 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034171 [ RunTime:0.002079s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (900498,67843,185516,622404,848200,408791,992606,644783,849751,123433,668602,519803,699195,142858,483013,1046996,659910,367878,800713,804381,923542,284528,228473,467015,92247,640151,240565,679102,514213,320095,418593,304077,239582,596054,904448,512761,216215,561166,898884,231913,794389,357527,828341,657321,706475,965729,801094,70279,652525,946762,547879,856697,1048072,564463,833482,154777,843089,537224,945922,1043697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]