SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 203551 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 203551 [ RunTime:0.002227s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020592,336702,927910,216617,832599,468920,460415,793030,369883,389425,634609,83525,415886,328285,719033,200063,306767,549820,910258,885213,413113,301653,6955,892837,151321,46555,960772,754267,776934,357220,40447,990871,415722,1040422,1020294,937633,719176,696424,441868,249727,802504,231241,272975,1015837,836235,527058,594727,678507,153501,116897,751013,334819,614732,42443,208826,847152,671043,277164,995717,83504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 203551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 203551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001128s ]