SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801580 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801580 [ RunTime:0.001839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270812,275809,769834,123777,1048421,713579,558284,626815,806424,619285,244110,836265,848086,9757,171125,615011,662783,675615,186236,450203,654324,580727,1000306,171817,485014,138941,74868,3979,957504,1029039,893410,18244,575439,369493,830079,235364,2603,434567,331801,976003,1030627,722140,872446,882912,632957,1048468,1027587,791532,977153,145915,113614,657460,130566,221731,338319,631771,468248,859994,24429,339310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]