SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001517s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477623 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477623 [ RunTime:0.001785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (127424,780299,381233,236151,570635,75277,268281,568553,541479,981755,99411,960572,393087,298664,603645,965809,932591,1034531,829758,598294,449151,943389,855093,494134,1007112,200833,18495,174160,731541,839270,795533,466300,857307,773812,669164,425202,1034441,127875,46876,542912,171955,944898,576155,586210,965011,54272,842111,239051,412900,433011,677441,598964,589082,53336,759971,753317,221232,946527,952855,163449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]