SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521039 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521039 [ RunTime:0.002423s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612755,807473,638604,209936,711211,603473,524292,698869,605915,287491,1040322,638588,567148,696469,193994,40854,1032313,616499,649413,880607,135839,879823,712010,693145,841981,658543,780442,321633,816617,501428,438906,284134,173933,935460,1002405,703845,27478,371045,228263,752004,157389,913049,99723,730722,266852,360696,723152,322546,459164,390289,857646,994382,207931,918601,634997,515876,1038313,209652,455767,375927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001829s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001628s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]