SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 980710 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 980710 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204230,385046,473109,128301,523815,81154,191020,824638,453072,15076,915127,539431,322029,688979,119467,547879,783107,378319,4130,523774,959887,929311,348435,398188,383537,746413,345386,668129,146502,130090,891693,586009,616496,994978,664572,982455,1040682,868980,794074,475153,505441,423573,978920,950559,912114,269578,933856,418768,114963,776996,271370,84200,676959,546450,261259,875112,889369,415703,861692,589075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000927s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 980710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 980710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]