SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005111 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005111 [ RunTime:0.001551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (806902,124730,678865,224861,429103,1009398,1011417,71537,364047,477649,612117,162349,927402,300459,236489,704083,770772,151786,706341,804588,355285,545296,694786,545527,331369,1045149,158243,860696,576386,1014140,532953,378332,149140,993172,131754,442880,347016,1009770,918248,927925,223572,153065,960271,99236,362900,792551,279769,150723,503962,371008,155295,840361,362500,735040,810465,342228,625597,203940,1034679,773262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]