SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101266 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101266 [ RunTime:0.001538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530154,644157,863292,774193,236617,246532,607528,774108,139978,844742,712322,102728,244439,309727,584006,662412,633600,1009399,232688,848986,289116,997504,645251,456253,140220,707004,123448,1007660,624617,298100,487396,236789,627767,509009,274119,694181,823950,89946,467635,166625,931503,974021,655580,909340,785869,196392,639880,510646,92711,159587,710700,472693,24607,113190,745237,49729,679952,338015,396289,239346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101266 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101266 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000331s ]