SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001693s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201076 LIMIT 1 [ RunTime:0.000517s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201076 [ RunTime:0.002447s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247470,944447,648104,193649,472571,84464,776960,919689,685445,569113,757761,234998,940071,936207,109978,622791,1018247,903439,611755,188412,34100,984160,656203,973885,938323,524163,794733,920360,474875,80867,817203,1020339,872162,777490,1034086,1009228,971099,749742,847101,995807,524245,377646,636676,983303,294346,181354,197557,294866,169122,682054,180038,288090,63333,96703,510784,481197,571875,735061,1015602,251908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002726s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201076 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201076 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]