SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034385 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034385 [ RunTime:0.002156s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501255,21663,655130,802117,115155,613280,355365,508057,807042,348140,999550,1043416,863160,350003,204481,269025,272103,89070,595388,535164,939296,435275,535344,812146,700271,1022223,120047,922957,795186,164592,870471,660327,844797,907756,140187,818762,953029,365447,350221,208616,410870,983472,344528,30891,502484,869272,8702,857055,85786,777934,153634,720731,118730,743464,94952,38316,529207,569245,302806,752987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034385 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000662s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034385 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001574s ]