SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.010867s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414023 LIMIT 1 [ RunTime:0.002300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414023 [ RunTime:0.005408s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (925673,357575,401667,560334,795386,805492,139142,552725,606807,902689,660332,870137,358639,26937,976468,495537,458985,54280,882679,627982,732883,41462,987052,517349,954117,344375,877998,351646,658796,991956,379897,563818,1033290,13343,653869,306558,1017849,922851,297368,840841,8501,236756,656419,111931,1045247,929400,556416,939628,646823,453309,404983,984688,586153,485163,393919,328908,453292,163551,799719,292878) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003713s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006181s ]