SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001462s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401368 LIMIT 1 [ RunTime:0.000765s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401368 [ RunTime:0.004983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (662517,621005,974358,36304,34801,513518,681620,609158,143838,10923,708551,969074,1014881,462088,838388,189764,330750,763877,316972,850648,514985,210688,818598,493447,300129,239297,672250,208217,219478,740556,531265,1003418,271443,420312,791704,800953,223857,212692,172150,853874,64412,496093,322691,49643,787685,449083,764634,695173,680392,756360,990483,592723,459796,546503,438514,639563,113599,488888,666748,562148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401368 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401368 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]