SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467861 LIMIT 1 [ RunTime:0.000507s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467861 [ RunTime:0.005552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (699081,117066,248918,167217,489629,982760,458146,731130,203760,938680,13105,1028169,829064,640037,1011704,987040,319466,684146,904939,744629,349001,396863,458876,226670,593551,442421,379091,888383,68318,157937,440480,150272,526402,968702,70693,1019198,851593,870604,941967,717547,924247,87860,176042,396100,829360,578003,855542,1001753,440276,810381,988842,444335,483352,188853,547348,995585,781108,1048598,3954,770205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001808s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]