SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042630 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042630 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (90447,974107,153605,427343,242447,221373,706284,496533,954438,789189,687951,259404,516083,817843,688024,872930,880240,683325,714910,658382,377979,663112,164996,995757,58590,917710,895162,199030,433437,63209,474809,872409,928659,132650,535949,510168,592316,408554,443490,788152,390846,690290,153968,112291,221706,771520,509816,655154,418408,533009,995798,180076,143655,483908,156308,650565,356548,1042408,979657,789923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042630 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042630 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]