SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043336 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043336 [ RunTime:0.002353s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793969,752946,489002,6515,243542,260105,734712,834345,593009,232184,419168,1018220,973871,79878,468863,648058,400499,197128,77802,495039,987147,301175,239454,109261,250220,350882,944148,651343,615943,745414,712448,661005,371538,745787,77041,1034421,1046013,898062,32615,891910,967446,57385,708501,46438,236791,609032,228232,1022732,261326,208441,749727,928301,176236,1019517,288359,73247,471831,823583,260772,783882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043336 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043336 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000832s ]