SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001764s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805050 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805050 [ RunTime:0.003569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (188599,788052,8264,1048706,353414,437294,333102,376457,463506,90632,175068,28581,385330,676505,662628,314980,83948,27320,914168,509899,220526,618909,941092,266982,825290,656168,360874,367400,540235,233828,952833,363945,737241,171057,256784,655775,347673,25768,926421,613226,396815,503900,316178,805343,606228,107780,973781,359140,174020,162843,871914,152449,44375,765961,11649,649784,210115,897055,146663,920136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]