SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451644 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451644 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843632,842144,415097,383954,778128,552152,463964,771649,966123,946692,199297,282815,517591,661966,409565,769744,135172,378447,1039581,577896,852955,195686,137600,783351,662438,443780,119213,852516,236655,514443,667510,665597,190630,636787,325248,258706,151804,631329,108029,666885,791409,71927,1346,701535,952198,195330,50493,341712,617076,690604,740547,248606,320711,993072,301136,638462,490489,270168,1010102,931338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451644 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451644 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000748s ]