SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 275013 LIMIT 1 [ RunTime:0.000527s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 275013 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537236,702685,943342,428278,742187,198711,266024,108180,835514,364213,432941,325050,921522,50668,377784,64274,980415,518893,238134,144843,277615,908261,330428,965590,788979,845374,303425,779849,344666,276476,149849,461916,549500,509826,487947,910731,808213,613469,440710,782898,198016,126525,897749,452025,403693,152110,448714,262971,249090,672179,874020,408872,813214,831027,266591,109970,75018,361926,216870,66516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 275013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 275013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]