SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 611210 LIMIT 1 [ RunTime:0.000644s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 611210 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000128,100297,499209,229064,903432,454909,695851,400369,163477,1040148,499243,341250,449267,931722,152275,933893,430571,468020,463799,118931,997224,84471,309304,98606,184555,942095,942910,221028,924647,488148,2428,967940,368063,417819,146335,993249,1024607,346142,416679,432795,174672,519937,298825,306528,690115,268268,174259,54058,482531,30435,162772,953506,242158,791809,355082,913137,21251,477278,249264,144228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 611210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 611210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]