SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193502 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193502 [ RunTime:0.002164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (278687,559110,613719,994329,774485,878937,648877,361181,271131,411119,848417,822789,838282,1012118,599552,544725,932465,778777,250195,712936,62727,404180,361850,417097,365840,779547,709202,775993,47958,773834,661122,255129,949265,622085,780523,383177,872530,718016,425209,324646,236149,209878,493515,381171,866437,1031101,921185,172832,864063,814008,1001560,498795,953561,642825,341218,808538,462160,514064,829444,747782) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193502 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193502 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]