SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54633 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54633 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332672,489938,431132,653400,426573,590965,180688,919625,191970,547783,942413,252472,127755,319963,479796,231602,478070,803129,512176,130139,966554,518373,301749,734148,391080,590214,175476,324831,9604,731035,544847,290689,866797,872931,897400,474242,562196,152616,123083,657478,219059,230990,1021863,633070,116443,232588,602821,769859,930475,195484,203021,76184,20663,39137,806965,805681,759566,528018,300305,311886) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54633 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54633 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]