SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009861 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009861 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547712,411606,392963,763739,340401,724290,40091,559955,565024,379111,985749,935923,413840,801073,436330,924986,868174,512291,56,47307,924429,621035,379559,845485,1010044,900636,13883,683998,1001073,43302,64762,604585,589933,748980,758568,635333,156792,603212,437356,758928,632239,118666,623533,174412,888555,96477,785597,819778,415951,309778,502967,949875,185262,43066,186903,54016,409773,232906,900915,402563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]