SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266080 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266080 [ RunTime:0.001919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (691580,470095,713225,1032229,74825,798758,22448,489395,352280,993613,522748,601001,188697,505076,871465,763154,562755,503826,462875,937696,419277,633334,904989,61846,989360,1005067,400831,608715,182007,977809,634711,765850,578004,977870,655043,727119,57715,225827,741353,841437,190734,349057,965002,106858,791984,129244,560437,761568,226436,1027017,293981,579877,913906,197604,750106,293730,54877,610584,376124,698629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]