SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000929s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500432 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500432 [ RunTime:0.004091s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102952,905990,374757,28626,920108,889691,466424,153417,509530,771404,739254,221423,1036408,625217,662904,919252,230831,205116,382559,887522,875302,934118,516627,856623,6389,956944,108043,647407,955871,974642,286891,1002205,670118,39655,839315,156397,1935,199685,143240,554137,354359,441103,844462,492220,606350,433060,826121,41842,907695,698234,1908,324861,511150,170098,89739,1034527,605376,686835,167270,875289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500432 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500432 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]