SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31083 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31083 [ RunTime:0.001541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (683438,835097,877020,692548,1036075,398680,85561,789302,1018035,484305,473480,689303,534100,613214,587149,59001,235444,741093,62871,699834,157740,577999,56136,416279,534968,279493,647522,422172,621746,459058,1001459,361427,754864,60517,760206,76026,123549,1027091,548411,906584,1004859,965468,126908,636095,488382,392577,1010125,37438,570622,246542,855531,545711,184731,740063,783071,732933,442288,158633,63371,809205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]