SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105421 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105421 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674705,851200,208364,494562,294737,815112,59123,470113,624956,690066,401417,853889,351488,529561,862401,1048339,28960,212509,636416,4793,842248,142497,743364,912136,318534,271991,548589,768721,608066,918428,753684,44090,494216,809468,428274,311582,887000,439155,421389,774052,357628,60769,55960,160835,1045163,516621,87479,170187,546059,747103,973219,27633,705953,47666,244169,65635,860845,928713,314446,630525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]