SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002708s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538912 LIMIT 1 [ RunTime:0.000657s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538912 [ RunTime:0.003151s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (299917,475904,615270,286875,309416,773496,518168,424187,601648,870319,197212,1011373,745080,277700,920929,875191,172655,744346,178026,992912,204332,735063,363659,952466,20580,876709,836421,179366,651737,343738,246864,174399,851083,897171,319666,485060,445193,395932,744710,447081,400986,531774,5350,874744,405908,140032,331562,22845,28192,252544,558183,123506,180448,229144,754106,941524,941193,593392,609341,38465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001348s ]