SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406315 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406315 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (901770,662563,14104,889922,987642,247587,860698,338202,585430,877103,149721,64379,904154,190256,759377,490965,570316,894436,645113,115099,199960,225746,880406,643324,750841,780430,851845,121593,80715,66959,304136,242009,132406,266130,784705,995418,397611,79246,202371,306376,234205,351400,802793,653877,369677,306131,327416,972636,708831,576843,371597,977404,91944,680652,647752,310347,825651,902379,654427,74378) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]