SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481130 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481130 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156952,83517,446581,398312,483844,1040923,401516,487259,471660,886412,910395,61408,341286,451655,35328,709003,811853,283249,877789,221808,809170,858950,589434,904317,792250,885574,587497,97158,696560,616677,674375,247771,160050,416654,381256,270041,570059,23542,778586,901955,801831,303753,255628,27968,127988,411261,549317,288359,691051,849453,84315,128457,251494,550630,555925,654149,43899,934544,292128,260921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481130 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481130 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]