SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982313 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982313 [ RunTime:0.001612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270411,43951,279139,587898,589695,803789,70849,350690,637602,991803,689734,558195,677785,410575,291230,124907,669385,238068,144344,972756,557983,751289,991624,932712,293768,425742,358443,590227,401518,790414,889024,10810,489655,181868,389996,260338,572982,450113,630071,107122,799731,866715,730454,385976,537626,760207,85012,1030581,9297,607836,333520,48801,297384,240036,344459,797844,618292,303264,161580,919234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]