SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505447 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505447 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733874,288492,984766,434644,594512,96938,728364,242205,595145,319272,533442,431437,336167,572784,817044,262097,1007471,998441,515313,302036,153390,840879,813678,252374,333094,235616,322229,934855,724738,571207,976375,544899,329048,978342,580113,999289,935001,309988,776336,772835,342854,72214,584107,520175,963822,8960,144698,264512,554756,299626,775554,346352,580775,715982,822545,1046862,203696,174290,639272,47810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]