SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452905 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452905 [ RunTime:0.001467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201535,363513,879431,515091,465566,43768,235316,771722,737476,694771,873875,824885,476515,14279,393893,1010833,696632,801168,608905,215236,361481,959057,898880,912858,676998,125989,627233,575756,672062,860712,580434,157298,290160,68189,977050,1016151,138593,815356,571210,183868,294500,303938,744728,1006334,158522,201980,462287,212334,526624,650861,1044216,348566,794805,739320,425052,214872,640146,948411,157666,306442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]