SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003536s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104113 LIMIT 1 [ RunTime:0.002050s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104113 [ RunTime:0.009196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (889907,455105,595270,755688,643885,624695,710314,638650,512789,488451,116328,921981,603114,539415,511213,172984,726462,697841,812998,28485,1007613,519349,367176,85672,441185,579706,694804,587677,552663,276913,349889,12976,45198,784870,75690,890635,152068,967888,972467,959751,553384,58422,50009,355391,988542,787420,849902,660954,327236,23332,480053,883606,421823,621101,707593,70764,350259,1039939,255344,1002865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]