SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502825 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502825 [ RunTime:0.002275s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (370457,887046,445662,623446,644362,567011,780030,170113,44580,821938,795342,944657,983528,933148,160481,847158,678911,1035813,717195,331135,791824,859411,292210,46029,466977,528645,92644,554754,226081,363346,438429,555180,428638,822540,421014,160758,676706,247722,16039,556037,746253,72999,789115,492028,936818,953702,904761,219902,488799,690078,882239,598976,594958,207353,686305,487758,677614,139076,947158,186926) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502825 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502825 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000904s ]