SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544956 LIMIT 1 [ RunTime:0.000624s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544956 [ RunTime:0.003478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532468,280758,2336,305542,27275,515230,73191,518341,887244,1013998,894384,635705,933831,227215,156205,632520,586115,744743,327238,98104,578487,989374,467813,13297,841381,126474,618885,866918,215955,408,984655,964651,549557,698171,681338,221436,418180,75097,510921,497708,724576,938925,92890,71416,557935,70053,760757,715958,416317,146558,902325,818504,37744,770701,861434,814877,272314,966879,871207,333756) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544956 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544956 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]