SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569853 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569853 [ RunTime:0.004365s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524468,744307,193475,144226,1016489,279794,392998,242507,1046727,268494,169065,189477,64393,180971,791304,94906,280722,1046404,153326,499025,895096,957360,478908,400827,828779,788647,386421,788903,270455,452594,1026608,363497,153162,337674,767161,85413,640331,799163,803623,969923,410728,144678,129850,692048,818408,814139,320484,757704,710864,508289,850909,612025,989585,869042,302784,461181,231992,538328,774880,673697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]