SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41502 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41502 [ RunTime:0.001484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249460,157082,642473,225512,881845,350908,474471,401809,589262,97599,528288,578336,844679,150894,345127,315060,702156,965308,1031090,805220,307716,101308,450819,551375,590688,937863,163080,983525,348263,174285,367813,896690,418220,483112,23436,122306,105589,321139,795174,545985,575365,775555,580707,230320,177184,151692,972420,777751,71382,635807,558048,786052,92099,750874,358264,504904,440183,225665,922653,576235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41502 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41502 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]