SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414602 LIMIT 1 [ RunTime:0.000650s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414602 [ RunTime:0.002561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211604,574923,972902,656148,836650,1034205,200525,231964,347987,495903,795998,537231,679957,1027500,115673,342345,232922,151544,211574,981545,42561,460518,530337,726476,586098,357742,947837,728584,472245,152722,812885,993036,132030,22411,642366,151703,815744,99255,816071,504065,511341,404467,88020,1029113,875576,544151,735214,585525,846558,199564,282663,66200,478228,175573,160455,227466,59152,604089,238872,933115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414602 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000798s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414602 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000842s ]