SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 14661 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 14661 [ RunTime:0.001986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286221,580962,211008,37361,750455,531285,751974,735089,859174,616837,201326,249553,756592,779446,347022,112820,692383,870486,454281,647345,634477,806154,973013,796787,352803,545708,251046,1013657,1040413,1046484,850470,659292,838008,512228,189357,659468,496289,315290,15425,792262,1041640,118311,351785,469425,331485,405229,276707,514151,1006143,926447,971899,125288,675628,844159,415143,769139,476928,8268,204361,850474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 14661 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 14661 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]