SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103409 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103409 [ RunTime:0.002057s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564223,372480,654125,793289,109972,463795,80464,960093,837754,687090,365104,225860,31503,446873,418046,71864,736894,815015,796969,501830,752611,156220,254590,496567,105417,586784,656456,639602,340388,352048,422693,492261,433772,151072,339291,890284,506012,153838,503265,317016,114314,153062,526626,679391,110662,166014,379069,153728,759204,444909,537176,1014568,600721,270456,497590,416412,481184,790768,442879,220584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001832s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]