SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029102 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029102 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368637,30277,459386,138345,920025,34532,795533,846826,981776,627352,775744,977625,503520,889433,334488,370400,134285,728084,79718,917427,816831,59700,542887,474635,220685,671846,335764,133448,153225,358196,70822,670371,703389,685771,41489,636503,871576,21528,929840,709655,503815,4133,647969,110567,526192,321885,601136,812985,63147,232496,269639,52190,1032463,1007777,402845,496112,297123,677729,110819,982815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000787s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001120s ]