SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450068 LIMIT 1 [ RunTime:0.000520s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450068 [ RunTime:0.001968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274652,832414,805211,333749,1011516,545519,514999,873852,463708,218214,333641,935961,397604,686714,152901,847635,521463,253440,653968,131687,623157,439818,732408,553992,965470,762578,464625,587095,531947,1025726,723799,152271,259582,252224,694998,699794,331698,914549,83852,641462,166385,561607,33884,187888,881913,837991,175588,149790,45157,780070,596416,354197,421508,695959,788796,1005131,570042,787781,783080,218919) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]