SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510700 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510700 [ RunTime:0.001989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120805,198891,214398,448724,417365,893693,687053,38113,861766,570206,500609,663636,542001,82322,711302,395065,377253,365375,544178,73861,536483,444108,226035,740828,902392,143327,941192,1005108,118111,389916,207175,572998,849166,1038777,742975,74866,718260,589883,488109,580642,162453,781339,9259,566103,309561,237640,654134,690135,155927,389909,746033,445261,873666,974601,367802,628210,351908,679311,136479,743771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.024800s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510700 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510700 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000717s ]