SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505448 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505448 [ RunTime:0.001873s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009679,673957,609026,322514,262386,535695,845103,660666,374120,866553,66990,972113,887149,73902,302071,517091,396490,410795,611017,1046771,855047,798114,354747,646393,551193,692946,503454,671846,542314,328289,867141,385626,325136,1037712,865409,546600,892762,907717,644044,655834,488616,240858,593572,110962,98019,818233,954700,356301,830882,541389,609739,767396,394770,619861,355608,472834,122229,130982,599828,165907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]