SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040876 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040876 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621427,1039478,985346,910083,305576,94689,272107,281928,739975,715588,581057,321733,999584,1033590,621442,383492,979724,460443,254370,638015,57753,793206,152201,60325,54673,200553,496959,27233,319833,772885,33911,861696,996930,272744,557156,612075,348865,1039659,878478,940115,342337,867604,798917,681581,986415,190445,984248,275726,780440,390660,997946,145766,714478,163554,735487,371019,862560,288241,756933,7343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]