SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001505s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580008 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580008 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487367,949709,881244,336480,639932,438591,455053,840072,506265,184368,863116,122120,538371,396084,860632,834362,535738,913414,276659,638923,153537,666784,902824,601603,363754,925607,762368,803369,460908,499629,357111,793273,668284,183631,901985,427037,214196,173932,818668,948094,981508,97938,107071,729833,150473,518848,772879,897624,1028317,769128,24563,908561,676869,191871,117510,860530,254252,193457,454025,569968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000824s ]