SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 576841 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 576841 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260366,299438,1001787,511960,529313,172504,514551,549942,627394,935491,320420,532766,186819,890326,267891,259204,970118,138373,65070,950780,914783,616265,581362,382187,584054,404108,393439,195689,108871,669438,886464,265448,428549,464389,1034183,190191,473582,550195,185245,894213,297865,919418,136951,169243,119356,190508,2099,299016,1010719,836794,831386,150572,944141,311099,355745,410899,372221,1036555,825552,370644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 576841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 576841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]