SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003528s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409163 LIMIT 1 [ RunTime:0.002791s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409163 [ RunTime:0.004214s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (863548,149111,109563,522972,417855,140872,996654,254698,492194,110070,904889,1032633,720498,515012,231413,963609,398127,310578,611432,179141,609625,105554,984025,369436,1047160,829415,209713,281337,47780,902543,281500,258946,197245,327756,998972,1012204,400402,432079,1022071,554157,204230,196676,1020481,1013454,609924,17195,745659,963891,264172,1037270,1042375,548393,673813,528790,168299,33383,394649,391207,973713,771507) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409163 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409163 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001827s ]