SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316506 LIMIT 1 [ RunTime:0.005501s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316506 [ RunTime:0.004514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566482,372830,612692,421013,28880,505871,735858,523220,322188,154679,353195,51107,916106,970917,856989,143404,472694,462386,353345,856603,407995,737088,519895,834511,260660,890815,146266,1014757,724835,503033,932427,502088,551755,32000,762752,896728,86560,140710,14546,306025,83578,824932,403326,552050,947022,976250,885168,429997,384806,133519,535628,871264,642012,85077,919160,135258,616512,304029,786445,992894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000727s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004162s ]