SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 800040 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 800040 [ RunTime:0.003604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841071,64078,501793,671112,130874,600697,1017563,188279,998742,1030318,151482,459830,811948,479542,800927,892770,70519,143886,337789,646837,531512,203494,865533,131996,107341,662315,401728,900339,743778,880377,241295,214866,622427,73348,837421,239187,781552,88216,638594,1002177,783927,742149,927404,841345,68693,31011,627534,80102,936943,261184,40338,540360,545599,143094,332532,142304,457216,136258,859791,272765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 800040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 800040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]