SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416121 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416121 [ RunTime:0.001943s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (860531,29851,303007,932332,866697,980426,462669,213019,753581,837507,845383,230567,306879,57219,1048279,193133,124490,157814,994875,118401,406424,314207,1036413,422195,990603,197660,316988,139801,853456,484304,756613,155680,969097,426601,697023,668955,646638,902280,827022,959198,787765,154350,75522,117109,638754,728826,901906,339977,773031,477733,162712,235037,686692,318447,392923,540730,262962,918899,903424,1031860) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416121 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416121 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]