SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004445s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532071 LIMIT 1 [ RunTime:0.003689s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532071 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733396,943844,552059,976203,745986,262931,310910,307872,663641,516116,1043219,733274,295840,273887,98411,998723,890120,186214,400008,139171,330596,762385,361659,968148,328070,613838,342847,934501,538211,445720,323146,179879,146513,734415,705039,213539,119328,436702,418103,306733,304843,864525,259087,810114,944951,635507,341960,754778,522518,575100,1018210,208846,652904,680651,309258,202983,95297,694560,657392,412085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]