SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501161 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501161 [ RunTime:0.003043s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504771,1021708,631737,850548,634475,1024295,439914,981348,117738,299971,142313,619655,669076,920803,985469,431458,1040843,943576,156119,971143,464737,759480,369114,809691,172215,800268,649296,62802,636509,981343,440848,247075,431489,393360,124858,137046,223478,991557,430798,442009,935656,243990,493367,8426,768361,347907,470761,464961,564007,574152,508042,392729,291701,606640,965529,482806,539480,655660,619138,703887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]