SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039188 LIMIT 1 [ RunTime:0.001050s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039188 [ RunTime:0.002078s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (389383,709833,328858,1044033,870226,334409,421251,335273,317514,312463,454225,407299,412133,492712,282144,57037,1035760,710824,757820,267800,197057,132742,390731,545014,544874,893395,408515,730530,777740,70927,315678,859272,541381,748630,380516,347263,765288,736714,768740,498348,909150,372914,414556,832215,919524,133368,698523,729076,735379,564116,285457,1039801,404573,660555,186374,644759,457981,535976,710344,892605) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]