SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037198 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037198 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342540,938011,682992,724737,909262,217253,88469,719183,1013504,1040701,236163,635138,295389,906459,1003884,392178,835801,685028,50942,629659,644738,29037,715620,21412,879099,890809,826693,453373,807970,363100,907099,653848,864069,1021687,40637,155993,642664,694968,383879,579250,1040217,705942,769621,666296,155577,447013,226482,482834,662352,103888,220255,354128,375119,319405,656862,443589,77426,194858,940630,217425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]