SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 917198 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 917198 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404114,228217,40589,602642,379391,395097,567157,463048,132307,564394,189132,242635,1043388,304475,497708,308191,748781,171787,555084,882730,601140,288912,243761,985447,890145,215603,493276,342456,288330,801685,744041,249790,794858,1005516,339761,32880,456430,556723,284818,41838,1005818,447685,936680,502332,747344,224365,261916,141834,420697,296004,295546,173029,496496,760452,878148,375951,572564,401307,833229,510890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 917198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 917198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]