SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001620s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546711 LIMIT 1 [ RunTime:0.000540s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546711 [ RunTime:0.002370s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (70740,692390,280308,885939,933910,678446,637713,692348,866156,198485,761049,807865,235422,271147,262227,615588,346026,573671,265929,190757,60012,468130,68147,577505,13754,271274,652257,106138,1047370,42762,144827,987111,36208,1008912,184280,472141,12874,344793,576705,853471,1034016,981834,133971,3793,217853,406858,447866,862873,297247,105899,196493,812638,143787,1034516,890035,238497,103870,1035346,419187,218873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001785s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]