SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023523 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023523 [ RunTime:0.001846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1025661,170843,877680,492773,627437,411832,251010,162376,765917,81310,731501,2516,793299,602852,40098,126659,202129,619122,108302,965516,67422,528484,392650,83757,1003435,552761,649492,983854,111426,858297,956775,791912,171558,437489,289539,779536,652700,899548,452645,728157,170370,262943,402888,422987,653387,451634,825942,955456,523938,210089,106592,198844,271705,234406,92746,478736,52836,137724,511778,997136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]