SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039568 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039568 [ RunTime:0.002130s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599640,512028,371866,214834,836507,1044589,251779,772604,1028424,50091,739575,452365,202004,117330,997691,278911,569694,350763,361798,1047134,346160,197070,284456,136845,742516,940002,997829,281269,468384,535847,298690,380625,980967,529603,627348,915291,200151,1044218,203499,385367,126316,372174,403000,787814,893964,645639,908225,593699,611348,278253,492928,673256,186396,566761,547983,664266,609639,926900,97842,413621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]