SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310206 LIMIT 1 [ RunTime:0.002963s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310206 [ RunTime:0.003019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (165045,327122,376090,551930,412119,994748,849216,710346,106910,674885,268814,371595,480638,280791,321805,748783,381332,1030750,1026208,386986,58081,482635,503075,441857,617052,1026311,794268,13142,277624,659138,462561,936028,673539,30023,902114,864947,158700,116163,184587,67834,373326,662207,95495,892138,164186,101068,620804,572442,575900,616359,879676,597473,418968,446782,202884,374602,1034729,277194,1012502,154793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001905s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001235s ]