SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014074 LIMIT 1 [ RunTime:0.001046s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014074 [ RunTime:0.003036s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (884604,848135,574235,831009,686803,746340,54471,161053,1029614,338112,264128,943416,565268,915325,329359,16101,14943,942203,493164,14744,498902,287548,404728,94876,68988,366979,175993,797391,518376,608744,897110,28639,99189,75419,888110,1028502,870714,177135,484489,250444,591009,705275,455639,711496,994171,817249,25943,641100,680554,514168,33527,774160,931499,836617,917748,967910,1026923,416341,67589,344103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014074 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014074 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]