SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 579508 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 579508 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (966717,991206,994010,309610,841404,246151,845047,206152,83231,948333,385689,120009,233539,406064,292319,739448,911888,928230,309257,429768,207253,975330,302622,895560,480889,175106,966640,771345,33130,236763,268335,1017238,19757,334186,713703,1017311,305652,904152,1045798,137984,255837,225917,697031,757552,235076,172228,987670,22353,997284,766051,3101,815653,858529,1007322,165931,267070,210851,921106,413630,314180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003714s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 579508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001835s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 579508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000980s ]