SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409612 LIMIT 1 [ RunTime:0.000506s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409612 [ RunTime:0.003263s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159557,788829,1037707,800999,546631,318378,889908,203904,215009,333180,566041,295651,489751,408062,593568,417280,437141,574385,243250,111650,517781,547448,271458,487311,22196,392036,702463,1007223,933222,582351,918414,315750,128978,81036,808007,133115,636116,524632,724167,141722,304912,99090,929498,325585,717928,593658,144811,839220,481961,45773,457868,241257,904131,951084,477153,127703,110161,802395,375646,323846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]