SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505458 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505458 [ RunTime:0.002177s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (824548,1032902,1015971,957317,2246,855969,164763,278681,619229,504740,332393,593731,114475,229118,799058,732578,917285,280752,239109,366415,416380,417361,165098,414280,927825,545150,84838,260887,921787,756176,479978,863730,4316,677876,218164,288119,314361,611754,392496,128043,473565,213348,614405,577879,530371,641209,975522,1048464,100692,42790,279045,658776,41830,691758,443610,273544,420396,786884,699154,171650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000970s ]