SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410668 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410668 [ RunTime:0.002632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300842,17423,971019,468956,486703,615167,292746,1043484,298516,979103,217606,444137,17059,882300,270377,461066,303150,388462,916560,515662,679659,770015,33495,397003,415602,757961,531800,140938,580695,127452,969632,154495,56515,672332,282989,197529,547798,975873,544110,897765,296550,722763,955129,741849,207296,442832,230850,636598,863797,505472,192122,873550,733592,379005,67830,611881,393484,703299,945462,871210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]