SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001795s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017566 LIMIT 1 [ RunTime:0.000563s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017566 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964765,878998,480429,352638,224274,666993,824244,18358,985282,104500,235225,863221,628011,937301,772836,850544,874739,266954,52290,572176,1828,401887,312049,41116,933172,431451,761466,569066,545063,861263,445212,369365,1025681,306646,941236,109365,652604,527833,59614,161993,438968,354988,1041299,449480,67747,213590,472785,626962,105385,437692,376273,571330,939477,652652,165180,162287,880743,908391,65689,407938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017566 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017566 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]