SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 856480 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 856480 [ RunTime:0.001995s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706750,442585,717966,267872,689293,602463,878044,981992,840206,912417,23928,1022760,449690,515711,990818,91273,1019232,354328,602743,105961,267177,422768,460689,546657,819892,902655,594408,754238,316637,92362,293429,544516,440742,138484,173479,378124,437287,821398,330042,794419,816594,912330,419288,1011346,513498,732319,803125,759565,428565,388391,837062,17713,732123,235887,839695,328443,736929,200546,363265,502222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 856480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 856480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002205s ]