SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001506s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 587041 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 587041 [ RunTime:0.001921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52218,450162,372150,241551,115494,290055,715844,967673,596756,702096,41120,742377,958253,5338,594244,490051,1003109,393412,910896,573725,377035,148032,14479,501442,143291,940362,333516,58951,392497,651525,1027490,326385,698459,702684,9076,311597,405053,994690,389355,899968,121025,818682,659680,869033,1043291,956179,440094,559146,405750,679198,257707,277444,633735,32464,409243,443592,510258,480150,476787,312516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 587041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 587041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]