SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508831 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508831 [ RunTime:0.003924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (390554,785636,767497,469765,689500,427753,370646,261844,566988,508054,1035591,414877,81917,592436,216312,615317,1043291,526690,1016432,897863,376831,490758,125838,862669,450917,738770,687170,556346,587513,834825,877183,611764,120751,652319,630634,1882,830314,719166,672299,761155,302243,824928,167926,471942,464210,374327,772136,255002,122034,373326,859440,148039,764526,1307,114738,437920,769576,261323,1037915,514553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]