SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 118203 LIMIT 1 [ RunTime:0.000618s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 118203 [ RunTime:0.003548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555422,1001911,657439,60420,379830,134,401523,546087,700235,120046,393962,215344,134244,341177,566877,833856,423410,822060,883833,73940,662808,721360,349699,63830,399877,722527,188926,866346,354793,26605,378750,428173,677768,683079,1003871,305896,225317,594532,243459,17836,207204,890904,707381,703819,356564,422461,958750,473365,537051,75735,888040,1036150,286584,244153,522655,894225,940150,500375,504515,205903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 118203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 118203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000753s ]