SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024827 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024827 [ RunTime:0.002000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (631070,480603,364303,629492,268809,88576,993702,452524,488551,518288,202617,314472,974610,981494,249712,494242,816540,808475,949889,677318,1033633,662169,1018972,209481,275520,334445,767041,649861,273616,48545,161617,865169,836771,27413,403039,674220,714959,747453,994769,346240,495961,849190,806033,381867,627490,547614,871432,235389,335036,1047433,440163,661937,690940,24580,1003869,921596,515191,966702,978908,815262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024827 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024827 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]